/*
CREATE TABLE "base_policy_document" (
  "sequence_nbr" text NOT NULL,
  "area_id" integer(20) NOT NULL,
  "city_name" text(30),
  "pricesource" text(255),
  "name" text(255) NOT NULL,
  "sketch" text(255),
  "release_date" text(12),
  "execute_date" text(12),
  "file_type" integer(4),
  "file_date" text(255),
  "file_url" text(1024),
  "remark" text(255),
  "rec_user_code" text(32),
  "rec_status" text(4),
  "rec_date" integer(20),
  "extend1" text(64),
  "extend2" text(64),
  "extend3" text(64),
  "description" text(255),
  "agency_code" text(64),
  "product_code" text(64),
  "zhyg_level1" real(16,2),
  "zhyg_level2" real(16,2),
  "zhyg_level3" real(16,2)
);
*/

use rbatis::crud;
use serde::{Deserialize, Serialize};
#[derive(Debug, Serialize, Deserialize)]
pub struct BasePolicyDocument {
    pub sequence_nbr: String,
    pub area_id: Option<i32>,
    pub city_name: Option<String>,
    pub pricesource: Option<String>,
    pub name: Option<String>,
    pub sketch: Option<String>,
    pub release_date: Option<f64>,
    pub execute_date: Option<f64>,
    pub file_type: Option<f64>,
    pub file_date: Option<f64>,
    pub file_url: Option<f64>,
    pub remark: Option<String>,
    pub rec_user_code: Option<String>,
    pub rec_status: Option<String>,
    pub rec_date: Option<String>,
    pub extend1: Option<String>,
    pub extend2: Option<String>,
    pub extend3: Option<String>,
    pub description: Option<String>,
    pub agency_code: Option<String>,
    pub product_code: Option<String>,
    pub zhyg_level1: Option<f64>,
    pub zhyg_level2: Option<f64>,
    pub zhyg_level3: Option<f64>,
}
crud!(BasePolicyDocument {}, "base_policy_document");
